/*
 Navicat Premium Dump SQL

 Source Server         : 125.94.106.113-train
 Source Server Type    : MySQL
 Source Server Version : 50726 (5.7.26-log)
 Source Host           : 125.94.106.113:3306
 Source Schema         : train_db

 Target Server Type    : MySQL
 Target Server Version : 50726 (5.7.26-log)
 File Encoding         : 65001

 Date: 27/09/2025 02:19:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) COLLATE utf8mb4_bin DEFAULT '' COMMENT '部门名称',
  `order_num` int(11) DEFAULT '0' COMMENT '显示顺序',
  `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `customer_id` bigint(20) DEFAULT '0' COMMENT '客户ID（租户ID）',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (202, 0, '0', '恒有科技', 0, '0', 1794315692181467138, 'admin', '2024-05-25 18:32:52', '', '2024-05-25 22:52:26', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (204, 202, '0,202', '一级部门3', 0, '0', 1794315692181467138, '19923456786', '2024-05-25 20:44:28', '', '2024-05-25 20:50:42', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (205, 204, '0,202,204', '二级部门', 0, '1', 1794315692181467138, '19923456786', '2024-05-25 20:59:35', '', '2024-05-25 22:52:58', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (206, 0, '0', '企业名称1', 0, '0', 1800555632670412802, 'admin', '2024-06-11 23:48:10', '', '2024-06-11 23:48:10', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (209, 0, '0', '恒有科技22', 0, '0', 1800888187277717506, 'admin', '2024-06-12 21:49:37', '', '2024-06-12 21:49:37', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (210, 0, '0', '新增企业1', 0, '0', 1802253525630509057, '17620722788', '2024-06-16 16:14:59', '', '2024-06-16 16:14:59', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (211, 205, '0,202,204,205', '业务一线第一组', 0, '0', 1802253525630509057, '17620722787', '2024-06-19 22:02:29', '', '2024-06-19 22:02:29', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (212, 205, '0,202,204,205', '业务一线第二组', 0, '0', 1802253525630509057, '17620722787', '2024-06-19 22:02:29', '', '2024-06-19 22:02:29', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (213, 205, '0,202,204,205', '业务一线第三组', 0, '0', 1802253525630509057, '17620722787', '2024-06-19 22:02:29', '', '2024-06-19 22:02:29', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (214, 206, '0,206', '子部门1', 0, '0', 1800555632670412802, '17620722788', '2024-06-23 17:16:14', '', '2024-06-23 17:16:14', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (215, 206, '0,206', '子部门2', 0, '0', 1800555632670412802, '17620722788', '2024-06-23 17:18:26', '', '2024-06-23 17:18:26', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (216, 215, '0,206,215', '子部门2-1', 0, '0', 1800555632670412802, '17620722788', '2024-06-23 17:33:29', '', '2024-06-23 17:33:29', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (217, 214, '0,206,214', '子部门1-1', 0, '0', 1800555632670412802, '17620722788', '2024-06-23 17:36:00', '', '2024-06-23 17:36:00', 0);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (218, 217, '0,206,214,217', '子部门1-1-1', 0, '0', 1800555632670412802, '17620722788', '2024-06-23 17:36:50', '', '2024-06-23 17:36:50', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_file_upload
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_upload`;
CREATE TABLE `sys_file_upload` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `file_md5` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件md5',
  `file_path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件相对路径',
  `file_content_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件内容类型',
  `file_extension` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件后缀扩展名',
  `file_size` decimal(38,0) DEFAULT NULL COMMENT '文件大小(单位b)',
  `file_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件名称',
  `file_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件分类（''WORD'',''PPT'',''EXCEL'',''PDF'',''IMAGE'',''VIDEO'',''AUDIO'',''FLASH''）',
  `storage_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '存储类型：（1-本地；2-对象存储）',
  `bucket_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'S3桶名称',
  `file_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件key名称',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '是否删除（0-否；1-是）',
  `file_desc` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件描述',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_file_entity_file_md5` (`file_md5`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1800851983908081666 DEFAULT CHARSET=utf8mb4 COMMENT='文件实体表';

-- ----------------------------
-- Records of sys_file_upload
-- ----------------------------
BEGIN;
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1793301682355097602, 'e23cfeb65622046513c2d0b3ba7ff219', '/static/20240522/03419c6ae57a4dada830cca1805ce4df.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'xlsx', 13825, '成都MIMO需求列表xlsx.xlsx', 'EXCEL', '1', NULL, '03419c6ae57a4dada830cca1805ce4df.xlsx', 'admin', '2024-05-22 23:23:34', 'admin', '2024-05-22 23:23:34', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1794364433001267202, '367ab9afc33556afb99eba6121b3b727', '/static/20240525/2940bb402c6a46e4b00da7ea2f03242f.doc', 'application/msword', 'doc', 75138, '架构设计方案模板.doc', 'WORD', '1', NULL, '2940bb402c6a46e4b00da7ea2f03242f.doc', '19923456786', '2024-05-25 21:46:33', '19923456786', '2024-05-25 21:46:33', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800538772004540418, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/a3e6cf32df6d4a86a601b1c8c2a83491.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'a3e6cf32df6d4a86a601b1c8c2a83491.png', 'admin', '2024-06-11 22:41:10', 'admin', '2024-06-11 22:41:10', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800539256257908738, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/a097e6b638214caca079a0c7f45fa7ed.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'a097e6b638214caca079a0c7f45fa7ed.png', 'admin', '2024-06-11 22:43:06', 'admin', '2024-06-11 22:43:06', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800539498659319810, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/be1b9ac8221a48ffaf5eabe553b99d9b.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'be1b9ac8221a48ffaf5eabe553b99d9b.png', 'admin', '2024-06-11 22:44:04', 'admin', '2024-06-11 22:44:04', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800540359397609474, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/d6b976df65034d8f84a09b995a8c7677.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'd6b976df65034d8f84a09b995a8c7677.png', 'admin', '2024-06-11 22:47:29', 'admin', '2024-06-11 22:47:29', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800541428248875009, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/f43c437e256b4bab861ef5241edb4c0d.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'f43c437e256b4bab861ef5241edb4c0d.png', 'admin', '2024-06-11 22:51:44', 'admin', '2024-06-11 22:51:44', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800554834913792001, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/c90cf00f3dc94fb5a2844f8d5389f7b4.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, 'c90cf00f3dc94fb5a2844f8d5389f7b4.png', 'admin', '2024-06-11 23:45:00', 'admin', '2024-06-11 23:45:00', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800555021413519361, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/5bb4428334f24d40b60bc88c31e854c4.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, '5bb4428334f24d40b60bc88c31e854c4.png', 'admin', '2024-06-11 23:45:44', 'admin', '2024-06-11 23:45:44', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800555225181196289, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/0c7a6b2d5b184b1eb46a5c478619e6c6.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, '0c7a6b2d5b184b1eb46a5c478619e6c6.png', 'admin', '2024-06-11 23:46:33', 'admin', '2024-06-11 23:46:33', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800555556833202178, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240611/62c4efcd8bfa409fb15ea3bdb9d34ce5.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, '62c4efcd8bfa409fb15ea3bdb9d34ce5.png', 'admin', '2024-06-11 23:47:52', 'admin', '2024-06-11 23:47:52', '0', NULL);
INSERT INTO `sys_file_upload` (`id`, `file_md5`, `file_path`, `file_content_type`, `file_extension`, `file_size`, `file_name`, `file_type`, `storage_type`, `bucket_name`, `file_key`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`, `file_desc`) VALUES (1800851983908081665, 'a57b6f31fa77c50f14d756711dea4158', '/static/20240612/5cb0b06988e740ada24138dc2496d67b.png', 'image/png', 'png', 98071, '404.png', 'IMAGE', '1', NULL, '5cb0b06988e740ada24138dc2496d67b.png', 'admin', '2024-06-12 19:25:46', 'admin', '2024-06-12 19:25:46', '0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `pid` bigint(20) NOT NULL COMMENT '上级菜单ID',
  `type` int(11) NOT NULL COMMENT '菜单类型',
  `title` varchar(255) DEFAULT '' COMMENT '菜单标题',
  `name` varchar(255) DEFAULT '' COMMENT '组件名称',
  `component` varchar(255) DEFAULT '' COMMENT '组件',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `icon` varchar(255) DEFAULT '' COMMENT '图标',
  `path` varchar(255) DEFAULT '' COMMENT '链接地址',
  `iframe` bit(1) DEFAULT b'0' COMMENT '是否外链',
  `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
  `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
  `permission` varchar(255) DEFAULT '' COMMENT '权限',
  `menu_category` char(2) DEFAULT '3' COMMENT '菜单分类（0-运营管理用户，1-企业管理用户，3-全部可见）',
  `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1802355724012363778 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1645812231633461249, 1647248318234886145, 0, '二级菜单1', '', '', 1000, 'table', 'menu', b'0', b'0', b'0', '', '3', 'system', 'system', '2023-04-11 23:33:08', '2023-04-11 23:33:08', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1645812547225477122, 1645812231633461249, 1, '三级菜单1', 'menu3-1', 'nested/menu1/menu1-1/index', 1000, 'chain', 'menu3-1', b'0', b'0', b'0', '', '3', 'system', 'system', '2023-04-11 23:34:24', '2023-04-11 23:39:59', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1645812820081729537, 1647248318234886145, 1, '二级菜单2', 'menu2-2', 'nested/menu2/index.vue', 1000, 'app', 'menu2-2', b'0', b'0', b'0', '', '3', 'system', 'system', '2023-04-11 23:35:29', '2023-04-11 23:37:20', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1645813802001850369, 1645812231633461249, 1, '三级菜单2', 'menu3-2', 'nested/menu1/menu1-2/index', 1000, 'email', 'menu3-2', b'0', b'0', b'0', '', '3', 'system', 'system', '2023-04-11 23:39:23', '2023-04-11 23:39:23', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1646104022067286017, 1647247627433017346, 1, '树形表格', 'TreeTable', 'tree-table/index', 1000, 'tree-table', 'tree-table', b'0', b'0', b'0', '', '3', 'admin', 'admin', '2023-04-12 18:52:37', '2023-04-15 22:43:12', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1646917867762913282, 1800341904968556545, 1, '账号管理', 'user', 'system/user/index', 100, 'user', 'list', b'0', b'0', b'0', 'user:list', '0', 'admin', 'admin', '2023-04-15 00:46:33', '2024-06-11 09:53:23', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1647245235475972097, 0, 0, '系统监控', 'Monitor', '', 200, 'monitor', '/monitor', b'0', b'0', b'1', '', '3', 'admin', 'admin', '2023-04-15 22:27:23', '2024-03-09 14:04:29', 1);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1647245914567344129, 1647245235475972097, 1, 'SQL监控', 'Druid', 'monitor/druid/index', 1000, 'sqlMonitor', 'druid', b'0', b'0', b'0', '', '3', 'admin', 'admin', '2023-04-15 22:30:05', '2024-03-09 14:04:23', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1647246715431944194, 1647245235475972097, 1, '接口文档', 'Swagger', 'monitor/swagger/index', 1000, 'doc', 'swagger', b'0', b'0', b'0', '', '3', 'admin', 'admin', '2023-04-15 22:33:16', '2023-04-15 22:33:31', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1647247627433017346, 0, 0, '组件管理', 'Components', '', 300, 'zujian', '/components', b'0', b'0', b'1', '', '3', 'admin', 'admin', '2023-04-15 22:36:53', '2024-03-09 14:04:43', 1);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1647248318234886145, 0, 0, '多级菜单', 'Menus', '', 1000, 'theme', '/menus', b'0', b'0', b'1', '', '3', 'admin', 'admin', '2023-04-15 22:39:38', '2024-03-09 14:04:37', 1);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800341904968556545, 0, 0, '账号管理', 'Layout', '', 10, 'Steve-Jobs', '/userManage', b'0', b'0', b'0', '', '0', 'admin', 'admin', '2024-06-11 09:38:54', '2024-06-11 15:29:31', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800362158188830722, 0, 0, '客户管理', 'Layout', '', 20, 'permission', '/orgManage', b'0', b'0', b'0', '', '0', 'admin', 'admin', '2024-06-11 10:59:22', '2024-06-11 15:29:38', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800364090366271489, 1800362158188830722, 1, '客户管理', 'list', 'orgManage/index', 1000, 'permission', 'list', b'0', b'0', b'0', 'org:list', '0', 'admin', 'admin', '2024-06-11 11:07:03', '2024-06-11 11:07:27', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800367942033383425, 0, 0, '测评管理', 'Layout', '', 30, 'dept', '/eval', b'0', b'0', b'0', '', '0', 'admin', 'admin', '2024-06-11 11:22:21', '2024-06-11 15:29:45', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800369470198685698, 1800367942033383425, 1, '职能管理', 'function', 'evaluation/function/index', 10, 'zhineng', 'function', b'0', b'0', b'0', 'evaluation:function', '0', 'admin', 'admin', '2024-06-11 11:28:26', '2024-06-11 17:08:46', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800370839483752449, 1800367942033383425, 1, '天赋优势', 'advantage', 'evaluation/advantage/index', 50, 'tianfuyoushi', 'advantage', b'0', b'0', b'0', 'evaluation:advantage', '0', 'admin', 'admin', '2024-06-11 11:33:52', '2024-06-11 17:09:22', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800371926261473281, 1800367942033383425, 1, 'PDCA', 'pdca', 'evaluation/pdca/index', 60, 'pdca', 'pdca', b'0', b'0', b'0', 'evaluation:pdca', '0', 'admin', 'admin', '2024-06-11 11:38:11', '2024-06-11 17:09:35', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800430097684406274, 0, 0, '解决方案', 'Layout', '', 40, 'validCode', '/scheme', b'0', b'0', b'0', '', '0', 'admin', 'admin', '2024-06-11 15:29:20', '2024-06-11 15:29:51', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800431682766413825, 1800430097684406274, 1, '解决方案', 'list', 'scheme/index', 1000, 'validCode', 'list', b'0', b'0', b'0', 'scheme:list', '0', 'admin', 'admin', '2024-06-11 15:35:38', '2024-06-11 15:35:47', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800432698366795778, 1800367942033383425, 1, 'Q-sort', 'qsort', 'evaluation/qsort/index', 20, 'qiniu', 'qsort', b'0', b'0', b'0', 'evaluation:qsort', '0', 'admin', 'admin', '2024-06-11 15:39:40', '2024-06-11 17:08:58', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800433519083036673, 1800367942033383425, 1, '360', 'ths', 'evaluation/ths/index', 30, 'app', 'ths', b'0', b'0', b'0', 'evaluation:ths', '0', 'admin', 'admin', '2024-06-11 15:42:56', '2024-06-11 17:09:07', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800434060915810305, 1800367942033383425, 1, '高尔夫', 'golf', 'evaluation/golf/index', 40, 'timing', 'golf', b'0', b'0', b'0', 'evaluation:golf', '0', 'admin', 'admin', '2024-06-11 15:45:05', '2024-06-11 17:09:15', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800531961532780545, 1800362158188830722, 1, '新增客户', 'add', 'orgManage/edit', 1000, 'Steve-Jobs', 'add', b'0', b'0', b'1', 'orgManage:add', '0', 'admin', 'admin', '2024-06-11 22:14:07', '2024-06-11 22:14:07', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800532310389821441, 1800362158188830722, 1, '编辑客户', 'edit', 'orgManage/edit', 1000, 'Steve-Jobs', 'edit', b'0', b'0', b'1', 'orgManage:edit', '0', 'admin', 'admin', '2024-06-11 22:15:30', '2024-06-11 22:15:30', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800835020720836610, 0, 0, '组织管理', 'Layout', '', 21, 'Steve-Jobs', '/dept', b'0', b'0', b'0', '', '0', 'admin', 'admin', '2024-06-12 18:18:21', '2024-06-12 18:18:21', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800835306923364354, 1800835020720836610, 1, '组织管理', 'list', 'dept/index', 1000, 'peoples', 'list', b'0', b'0', b'0', 'dept:list', '0', 'admin', 'admin', '2024-06-12 18:19:30', '2024-06-12 18:19:30', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800854777402626049, 1800362158188830722, 1, '客户详情', 'info', 'orgManage/info', 1000, 'Steve-Jobs', 'info', b'0', b'0', b'1', 'orgManage:info', '0', 'admin', 'admin', '2024-06-12 19:36:52', '2024-06-12 19:36:52', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802351453699186690, 1800835020720836610, 1, '岗位管理', 'position', 'dept/position/index', 1000, 'Steve-Jobs', 'position', b'0', b'0', b'1', 'dept:position:list', '0', 'admin', 'admin', '2024-06-16 22:44:07', '2024-06-16 22:56:57', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355515807113218, 1800835020720836610, 1, '岗位新增', 'positionAdd', 'dept/position/edit', 1000, 'Steve-Jobs', 'positionAdd', b'0', b'0', b'1', 'dept:position:add', '0', 'admin', 'admin', '2024-06-16 23:00:16', '2024-06-16 23:00:16', 0);
INSERT INTO `sys_menu` (`id`, `pid`, `type`, `title`, `name`, `component`, `sort`, `icon`, `path`, `iframe`, `cache`, `hidden`, `permission`, `menu_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355724012363777, 1800835020720836610, 1, '岗位编辑', 'positionEdit', 'dept/position/edit', 1000, 'Steve-Jobs', 'positionEdit', b'0', b'0', b'1', 'dept:position:edit', '0', 'admin', 'admin', '2024-06-16 23:01:05', '2024-06-16 23:01:05', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` varchar(50) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(11) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `browser` varchar(255) DEFAULT NULL,
  `os` varchar(50) DEFAULT NULL,
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(4000) DEFAULT '' COMMENT '返回参数',
  `status` int(11) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',
  `create_by` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_sys_oper_log_bt` (`business_type`) USING BTREE,
  KEY `idx_sys_oper_log_s` (`status`) USING BTREE,
  KEY `idx_sys_oper_log_ot` (`oper_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1804915805270822915 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_position`;
CREATE TABLE `sys_position` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '岗位名称',
  `post_sort` int(11) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `status` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `customer_id` bigint(20) DEFAULT NULL COMMENT '客户ID（租户ID）',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1804450323489030146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_position
-- ----------------------------
BEGIN;
INSERT INTO `sys_position` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, 'BBB', '岗位2', 0, '0', 1794315692181467138, '19923456786', '2024-05-27 23:29:18', '', '2024-05-27 23:30:31', NULL);
INSERT INTO `sys_position` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `customer_id`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, 'A001', '销售人员', 0, '0', 1802253525630509057, '', '2024-06-19 10:15:55', '', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '名称',
  `code` varchar(64) NOT NULL DEFAULT '' COMMENT '角色编码',
  `level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '角色级别',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `data_scope` varchar(255) NOT NULL DEFAULT '' COMMENT '数据权限',
  `role_category` char(1) DEFAULT '3' COMMENT '菜单分类（0-运营管理用户，1-企业管理用户，3-全部可见）',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '更新者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_name` (`name`) USING BTREE COMMENT '角色名唯一索引',
  KEY `idx_code` (`code`) USING BTREE COMMENT '角色编码唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=1802253525966053378 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `code`, `level`, `description`, `data_scope`, `role_category`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1641112080616607746, '超级管理员', 'ADMIN', 1, '超级管理员', '全部', '0', 'system', 'system', '2023-03-30 00:16:25', '2023-04-09 23:07:29', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '更新者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_roleid_menuid` (`role_id`,`menu_id`) USING BTREE COMMENT '角色菜单唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=1802362419207872517 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435640226455554, 1800434982031106050, 1800341904968556545, 'admin', 'admin', '2024-06-11 15:51:22', '2024-06-11 15:51:22', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435640226455555, 1800434982031106050, 1646917867762913282, 'admin', 'admin', '2024-06-11 15:51:22', '2024-06-11 15:51:22', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435761961934849, 1800435524165869569, 1800367942033383425, 'admin', 'admin', '2024-06-11 15:51:51', '2024-06-11 15:51:51', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435761961934850, 1800435524165869569, 1800369470198685698, 'admin', 'admin', '2024-06-11 15:51:51', '2024-06-11 15:51:51', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435761961934851, 1800435524165869569, 1800370839483752449, 'admin', 'admin', '2024-06-11 15:51:51', '2024-06-11 15:51:51', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800435761961934852, 1800435524165869569, 1800371926261473281, 'admin', 'admin', '2024-06-11 15:51:51', '2024-06-11 15:51:51', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800436884676452354, 1800436802371624961, 1800430097684406274, 'admin', 'admin', '2024-06-11 15:56:18', '2024-06-11 15:56:18', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800436884676452355, 1800436802371624961, 1800431682766413825, 'admin', 'admin', '2024-06-11 15:56:18', '2024-06-11 15:56:18', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438282315014146, 1800437293449125889, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:01:52', '2024-06-11 16:01:52', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438282315014147, 1800437293449125889, 1800369470198685698, 'admin', 'admin', '2024-06-11 16:01:52', '2024-06-11 16:01:52', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438299943673857, 1800437480540250114, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:01:56', '2024-06-11 16:01:56', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438299943673858, 1800437480540250114, 1800432698366795778, 'admin', 'admin', '2024-06-11 16:01:56', '2024-06-11 16:01:56', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438313893928962, 1800437602338643970, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:01:59', '2024-06-11 16:01:59', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438313893928963, 1800437602338643970, 1800433519083036673, 'admin', 'admin', '2024-06-11 16:01:59', '2024-06-11 16:01:59', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438329895198722, 1800437981105266690, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:02:03', '2024-06-11 16:02:03', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438329895198723, 1800437981105266690, 1800434060915810305, 'admin', 'admin', '2024-06-11 16:02:03', '2024-06-11 16:02:03', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438404537032706, 1800438112504422401, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:02:21', '2024-06-11 16:02:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438404537032707, 1800438112504422401, 1800370839483752449, 'admin', 'admin', '2024-06-11 16:02:21', '2024-06-11 16:02:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438427442126850, 1800438248227905538, 1800367942033383425, 'admin', 'admin', '2024-06-11 16:02:26', '2024-06-11 16:02:26', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800438427442126851, 1800438248227905538, 1800371926261473281, 'admin', 'admin', '2024-06-11 16:02:26', '2024-06-11 16:02:26', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994882, 1641112080616607746, 1800367942033383425, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994883, 1641112080616607746, 1800341904968556545, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994884, 1641112080616607746, 1646917867762913282, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994888, 1641112080616607746, 1800362158188830722, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994889, 1641112080616607746, 1800364090366271489, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994890, 1641112080616607746, 1800532310389821441, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994891, 1641112080616607746, 1800531961532780545, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994892, 1641112080616607746, 1800854777402626049, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994893, 1641112080616607746, 1800369470198685698, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994894, 1641112080616607746, 1800370839483752449, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860436495994895, 1641112080616607746, 1800371926261473281, 'admin', 'admin', '2024-06-12 19:59:21', '2024-06-12 19:59:21', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860469140262914, 1800435158972014594, 1800362158188830722, 'admin', 'admin', '2024-06-12 19:59:29', '2024-06-12 19:59:29', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860469140262915, 1800435158972014594, 1800364090366271489, 'admin', 'admin', '2024-06-12 19:59:29', '2024-06-12 19:59:29', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860469140262916, 1800435158972014594, 1800532310389821441, 'admin', 'admin', '2024-06-12 19:59:29', '2024-06-12 19:59:29', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860469140262917, 1800435158972014594, 1800531961532780545, 'admin', 'admin', '2024-06-12 19:59:29', '2024-06-12 19:59:29', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800860469140262918, 1800435158972014594, 1800854777402626049, 'admin', 'admin', '2024-06-12 19:59:29', '2024-06-12 19:59:29', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800890118251405313, 1800888188246601729, 1800367942033383425, 'admin', 'admin', '2024-06-12 21:57:18', '2024-06-12 21:57:18', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800890118251405314, 1800888188246601729, 1800369470198685698, 'admin', 'admin', '2024-06-12 21:57:18', '2024-06-12 21:57:18', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607810, 1802253525966053377, 1800341904968556545, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607811, 1802253525966053377, 1800835020720836610, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607812, 1802253525966053377, 1800367942033383425, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607813, 1802253525966053377, 1800369470198685698, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607814, 1802253525966053377, 1800432698366795778, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607815, 1802253525966053377, 1800433519083036673, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607816, 1802253525966053377, 1800434060915810305, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607817, 1802253525966053377, 1800370839483752449, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607818, 1802253525966053377, 1800371926261473281, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607819, 1802253525966053377, 1800430097684406274, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607820, 1802253525966053377, 1646917867762913282, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607821, 1802253525966053377, 1800835306923364354, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525999607822, 1802253525966053377, 1800431682766413825, 'admin', 'admin', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355815376887810, 1800835516068139010, 1800835020720836610, 'admin', 'admin', '2024-06-16 23:01:27', '2024-06-16 23:01:27', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355815376887811, 1800835516068139010, 1802355724012363777, 'admin', 'admin', '2024-06-16 23:01:27', '2024-06-16 23:01:27', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355815376887812, 1800835516068139010, 1802355515807113218, 'admin', 'admin', '2024-06-16 23:01:27', '2024-06-16 23:01:27', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355815376887813, 1800835516068139010, 1800835306923364354, 'admin', 'admin', '2024-06-16 23:01:27', '2024-06-16 23:01:27', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802355815376887814, 1800835516068139010, 1802351453699186690, 'admin', 'admin', '2024-06-16 23:01:27', '2024-06-16 23:01:27', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678210, 1800555633047900162, 1800341904968556545, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678211, 1800555633047900162, 1800835020720836610, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678212, 1800555633047900162, 1800367942033383425, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678213, 1800555633047900162, 1800369470198685698, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678214, 1800555633047900162, 1800432698366795778, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678215, 1800555633047900162, 1800433519083036673, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678216, 1800555633047900162, 1800434060915810305, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678217, 1800555633047900162, 1800370839483752449, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678218, 1800555633047900162, 1800371926261473281, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678219, 1800555633047900162, 1800430097684406274, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678220, 1800555633047900162, 1646917867762913282, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678221, 1800555633047900162, 1800835306923364354, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419203678222, 1800555633047900162, 1802351453699186690, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419207872514, 1800555633047900162, 1802355515807113218, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419207872515, 1800555633047900162, 1802355724012363777, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802362419207872516, 1800555633047900162, 1800431682766413825, 'admin', 'admin', '2024-06-16 23:27:42', '2024-06-16 23:27:42', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `username` varchar(64) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(128) NOT NULL DEFAULT '' COMMENT '密码',
  `nick_name` varchar(64) NOT NULL DEFAULT '' COMMENT '昵称（姓名）',
  `gender` varchar(2) NOT NULL DEFAULT '' COMMENT '性别',
  `phone` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `email` varchar(32) NOT NULL DEFAULT '' COMMENT '邮箱',
  `avatar` varchar(128) NOT NULL DEFAULT '' COMMENT '头像',
  `enabled` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：0启用、1禁用',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `dept_name` varchar(20) DEFAULT '' COMMENT '管理人部门名称',
  `is_dept_leader` tinyint(1) DEFAULT '0' COMMENT '是否部门主管（0:否，1:是）',
  `position_id` bigint(20) DEFAULT '0' COMMENT '岗位ID',
  `position_name` varchar(20) DEFAULT '' COMMENT '岗位名称',
  `user_type` char(1) DEFAULT '2' COMMENT '用户类型（0-运营管理用户，1-企业管理用户，2-企业员工）',
  `is_etp_manager` tinyint(1) DEFAULT '0' COMMENT '是否企业管理员(0-否，1-是)',
  `customer_id` bigint(20) DEFAULT '0' COMMENT '客户ID（租户ID）',
  `member_name` varchar(20) DEFAULT '' COMMENT '客户会员名称',
  `use_limit` char(1) DEFAULT '0' COMMENT '使用期限（0-永久，1-有截止时间）',
  `deadline_time` date DEFAULT NULL COMMENT '截止时间',
  `has_expired` char(1) DEFAULT '0' COMMENT '企业服务是否到期（0-否，1-是）',
  `original_pwd` varchar(30) DEFAULT '' COMMENT '明文密码',
  `open_id` varchar(128) DEFAULT '' COMMENT '微信OpenId',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '更新者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_username_type` (`username`,`user_type`) USING BTREE COMMENT '用户名唯一索引',
  KEY `idex_cust_id` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1804885767703724035 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `password`, `nick_name`, `gender`, `phone`, `email`, `avatar`, `enabled`, `dept_id`, `dept_name`, `is_dept_leader`, `position_id`, `position_name`, `user_type`, `is_etp_manager`, `customer_id`, `member_name`, `use_limit`, `deadline_time`, `has_expired`, `original_pwd`, `open_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1639891860430286854, 'admin', '{bcrypt}$2a$10$gAFrq4.GAzIRU4lpwohDLO61DP32wkpYVdvSVbZP7RdmGxIwMzmgO', '超级管理员', '男', '13800009999', 'admin@163.com', '', 0, NULL, '', 0, 0, '', '0', 0, 0, '', '0', NULL, '0', '', '', 'system', 'admin', '2023-03-26 00:15:23', '2024-03-09 11:53:12', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '更新者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_userid_roleid` (`user_id`,`role_id`) USING BTREE COMMENT '用户id角色id唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=1802253525966053379 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1642178456714231810, 1642178456319967233, 1641112080616607746, 'system', 'system', '2023-04-01 22:53:49', '2023-04-01 22:53:49', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1642193090204667906, 1642193089843957761, 1641112080616607746, 'system', 'system', '2023-04-01 23:51:58', '2023-04-01 23:51:58', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1642481684953743361, 1642481684609810434, 1641112080616607746, 'system', 'system', '2023-04-02 18:58:44', '2023-04-02 18:58:44', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1642525847590137857, 1639891860430286855, 1641112080616607746, 'system', 'system', '2023-04-02 21:54:13', '2023-04-02 21:54:13', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1642568728493187073, 1642160690418417666, 1641112080616607746, 'system', 'system', '2023-04-03 00:44:37', '2023-04-03 00:44:37', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1643569855133241346, 1643569854785114113, 1641112080616607746, 'system', 'system', '2023-04-05 19:02:44', '2023-04-05 19:02:44', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1643570040752164866, 1643570040454369281, 1641112080616607746, 'system', 'system', '2023-04-05 19:03:28', '2023-04-05 19:03:28', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1645080111571046402, 1639891860430286854, 1641112080616607746, 'system', 'system', '2023-04-09 23:03:57', '2023-04-09 23:03:57', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800527005526396929, 1800459974563278849, 1800434982031106050, 'admin', 'admin', '2024-06-11 21:54:25', '2024-06-11 21:54:25', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800527005526396930, 1800459974563278849, 1800435158972014594, 'admin', 'admin', '2024-06-11 21:54:25', '2024-06-11 21:54:25', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800527005526396931, 1800459974563278849, 1800435524165869569, 'admin', 'admin', '2024-06-11 21:54:25', '2024-06-11 21:54:25', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800555633064677378, 1800555633026928641, 1800555633047900162, 'admin', 'admin', '2024-06-11 23:48:10', '2024-06-11 23:48:10', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1800888188481482754, 1800888188032692225, 1800888188246601729, 'admin', 'admin', '2024-06-12 21:49:38', '2024-06-12 21:49:38', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209601, 1802240780608626689, 1800434982031106050, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209602, 1802240780608626689, 1800835306923364354, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209603, 1802240780608626689, 1800436802371624961, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209604, 1802240780608626689, 1800437293449125889, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209605, 1802240780608626689, 1800437480540250114, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209606, 1802240780608626689, 1800437602338643970, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209607, 1802240780608626689, 1800438112504422401, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209608, 1802240780608626689, 1800437981105266690, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802240780621209609, 1802240780608626689, 1800438248227905538, '17620722788', '17620722788', '2024-06-16 15:24:21', '2024-06-16 15:24:21', 0);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `update_by`, `create_time`, `update_time`, `is_deleted`) VALUES (1802253525966053378, 1802253525949276162, 1802253525966053377, '17620722788', '17620722788', '2024-06-16 16:15:00', '2024-06-16 16:15:00', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_customer
-- ----------------------------
DROP TABLE IF EXISTS `t_customer`;
CREATE TABLE `t_customer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id（租户ID）',
  `company_code` varchar(20) NOT NULL DEFAULT '' COMMENT '企业客户编码',
  `company_name` varchar(255) NOT NULL DEFAULT '' COMMENT '企业名称',
  `english_name` varchar(64) NOT NULL DEFAULT '' COMMENT '英文名称',
  `company_address` varchar(255) NOT NULL DEFAULT '' COMMENT '企业地址',
  `company_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '企业电话',
  `company_fax` varchar(10) NOT NULL DEFAULT '' COMMENT '企业传真',
  `company_website` varchar(255) NOT NULL DEFAULT '' COMMENT '企业网址',
  `company_logo` varchar(255) NOT NULL DEFAULT '' COMMENT '企业LOGO',
  `create_by` varchar(255) NOT NULL DEFAULT '' COMMENT '创建者',
  `update_by` varchar(255) NOT NULL DEFAULT '' COMMENT '更新者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除（0:否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_compnay_name` (`company_name`) USING BTREE COMMENT '企业名称唯一索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='企业客户信息表';




CREATE TABLE a_audio_metric_rule(
	id  BIGINT AUTO_INCREMENT PRIMARY KEY,
	metric VARCHAR(30) NOT NULL COMMENT '指标英文名 avg_volume / volume_std',
	metric_name VARCHAR(30) NOT NULL COMMENT '指标中文名',
	unit VARCHAR(10) NOT NULL COMMENT '单位',
	base_val DOUBLE NOT NULL COMMENT '基准值',
	coeff  DOUBLE NOT NULL COMMENT '系数',
	score_min INT  NOT NULL COMMENT '最低得分',
	seq INT NOT NULL COMMENT '同一指标内区间顺序',
	score_min_in INT  NOT NULL COMMENT '区间最小分数（含）',
	score_max_in INT NULL COMMENT '区间最大分数（含），NULL 代表正无穷',
	level_code VARCHAR(10) NOT NULL COMMENT '等级编码',
	level_name VARCHAR(10) NOT NULL COMMENT '等级中文',
	description VARCHAR(100) NOT NULL COMMENT '提示文案',
	KEY idx_metric_seq (metric, seq),
	KEY idx_metric_score (metric, score_min_in)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='音频指标评分规则';


INSERT INTO a_audio_metric_rule
(metric,metric_name,unit,base_val,coeff,score_min,seq,score_min_in,score_max_in,level_code,level_name,description)
VALUES
/* ---------- 平均音量 dBFS ---------- */
('avg_volume','平均音量','dBFS',-18,3.3,30,1,0,59,'bad','需改进','声音偏低，听感吃力'),
('avg_volume','平均音量','dBFS',-18,3.3,30,2,60,79,'ok','可接受','音量可接受，再大声点更佳'),
('avg_volume','平均音量','dBFS',-18,3.3,30,3,80,100,'good','优秀','音量恰当，清晰有力'),
/* ---------- 音量标准差 dB ---------- */
('volume_std','音量标准差','dB',8.5,11.4,0,1,0,59,'bad','需改进','节奏过于平淡'),
('volume_std','音量标准差','dB',8.5,11.4,0,2,60,79,'ok','可接受','节奏起伏可接受，起伏再大点更佳'),
('volume_std','音量标准差','dB',8.5,11.4,0,3,80,100,'good','优秀','节奏张弛有度，富有表现力')，
/* ---------- 3. 净语速 words/min ---------- */
('net_speed','净语速','字/分',250,3,0,1,0,59,'bad','需改进','语速偏缓，略显拖沓'),
('net_speed','净语速','字/分',250,3,0,2,60,79,'ok','可接受','语速可接受，再快点更佳'),
('net_speed','净语速','字/分',250,3,0,3,80,100,'good','优秀','语速流畅自然，整体听感舒适'),
/* ---------- 4. 口头禅 次/分 ---------- */
('crutch_word','口头禅','次/分',0,10,0,1,90,100,'good','优秀','几乎无口头禅'),
('crutch_word','口头禅','次/分',0,10,0,2,70,89,'ok','可接受','偶尔出现轻微口头禅'),
('crutch_word','口头禅','次/分',0,10,0,3,20,69,'bad','需改进','多次出现口头禅'),
('crutch_word','口头禅','次/分',0,10,0,4,0,19,'bad','问题严重','非常频繁出现口头禅'),
/* ---------- 5. 重复或修正 次/分 ---------- */
('repeat_fix','重复或修正','次/分',0,10,0,1,90,100,'good','优秀','几乎无重复或修正'),
('repeat_fix','重复或修正','次/分',0,10,0,2,70,89,'ok','可接受','偶尔出现轻微重复或修正'),
('repeat_fix','重复或修正','次/分',0,10,0,3,20,69,'bad','需改进','多次出现重复或修正'),
('repeat_fix','重复或修正','次/分',0,10,0,4,0,19,'bad','问题严重','非常频繁出现重复或修正'),
/* ---------- 6. 长停顿 (>2s) 次/分 ---------- */
('long_pause','长停顿','次/分',0,20,0,1,60,100,'good','优秀','几乎无长时间停顿'),
('long_pause','长停顿','次/分',0,20,0,2,40,59,'ok','可接受','偶有出现轻微长时间停顿'),
('long_pause','长停顿','次/分',0,20,0,3,20,39,'bad','需改进','多次出现长时间停顿'),
('long_pause','长停顿','次/分',0,20,0,4,0,19,'bad','问题严重','非常频繁出现长时间停顿'),
/* ---------- 7. 眼神注视占比 % ---------- */
('eye_contact','眼神注视','%',100,0,20,1,80,100,'good','优秀','几乎全程保持目光交流'),
('eye_contact','眼神注视','%',100,0,20,2,60,79,'ok','可接受','大部分时间注视镜头'),
('eye_contact','眼神注视','%',100,0,20,3,20,59,'bad','需改进','多次出现眼神游离'),
('eye_contact','眼神注视','%',100,0,20,4,0,19,'bad','问题严重','极少注视镜头'),
/* ---------- 8. 面部表情积极占比 % ---------- */
('facial_expr','面部表情','%',100,0,20,1,80,100,'good','优秀','始终展现自然亲和的表情'),
('facial_expr','面部表情','%',100,0,20,2,60,79,'ok','可接受','大部分时间表情亲和'),
('facial_expr','面部表情','%',100,0,20,3,20,59,'bad','需改进','表情平淡或多次出现消极情绪'),
('facial_expr','面部表情','%',100,0,20,4,0,19,'bad','问题严重','长期表情状态不佳'),
/* ---------- 9. 头部姿态正面占比 % ---------- */
('head_pose','头部姿态','%',100,0,20,1,80,100,'good','优秀','始终保持正对镜头'),
('head_pose','头部姿态','%',100,0,20,2,60,79,'ok','可接受','大部分时间正对镜头'),
('head_pose','头部姿态','%',100,0,20,3,20,59,'bad','需改进','多次出现未正对镜头'),
('head_pose','头部姿态','%',100,0,20,4,0,19,'bad','问题严重','长期出现未正对镜头'),
/* ----------10. 心理压力（自信度）% ---------- */
('mental_stress','心理压力','%',100,5,0,1,80,100,'good','优秀','情绪状态自信稳定'),
('mental_stress','心理压力','%',100,5,0,2,60,79,'ok','可接受','比较放松，偶有轻微紧张情绪'),
('mental_stress','心理压力','%',100,5,0,3,30,59,'bad','需改进','比较紧张'),
('mental_stress','心理压力','%',100,5,0,4,0,29,'bad','问题严重','非常紧张');

-- ----------------------------
-- Records of t_customer
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
